﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using DLV.Utilities;

namespace DLV.Data.Entities
{
    public class TravelGuideCashController
    {
        public int InsertTravelGuideCash(TravelGuideCashInfo info)
        {
            return SQL.InsertTravelGuideCash(info.TravelGuideId, info.TravelGuidePriceId, info.BeginDate, info.EndDate, info.CreatedBy, info.CreatedDate, info.UpdatedBy, info.UpdatedDate, info.Status);
        }
        public void UpdateTravelGuideCash(TravelGuideCashInfo info)
        {
            SQL.UpdateTravelGuideCash(info.TravelGuideCashId, info.TravelGuideId, info.TravelGuidePriceId, info.BeginDate, info.EndDate, info.CreatedBy, info.CreatedDate, info.UpdatedBy, info.UpdatedDate, info.Status);
        }
        public void DeleteTravelGuideCash(TravelGuideCashInfo info)
        {
            DeleteTravelGuideCash(info.TravelGuideCashId);
        }
        public void DeleteTravelGuideCash(int travelGuideCashId)
        {
            SQL.DeleteTravelGuideCash(travelGuideCashId);
        }
        public TravelGuideCashInfo GetTravelGuideCash(int travelGuideCashId)
        {
            return CBO.FillObject<TravelGuideCashInfo>(SQL.GetTravelGuideCash(travelGuideCashId));
        }
        public List<TravelGuideCashInfo> ListTravelGuideCash()
        {
            return CBO.FillCollection<TravelGuideCashInfo>(SQL.ListTravelGuideCash());
        }
        public DataTable SelectTravelGuideCash()
        {
            return CBO.ConvertToDataTable(ListTravelGuideCash(), typeof(TravelGuideCashInfo));
        }
        public List<TravelGuideCashInfo> ListTravelGuideCashBySchedule(int scheduleId)
        {
            return CBO.FillCollection<TravelGuideCashInfo>(SQL.ListTravelGuideCashBySchedule(scheduleId));
        }
        public List<TravelGuideCashInfo> ListTravelGuideCashByIds(string travelGuideCashIds)
        {
            return CBO.FillCollection<TravelGuideCashInfo>(SQL.ListTravelGuideCashByIds(travelGuideCashIds));
        }
        public List<TravelGuideCashInfo> ListTravelGuideBy(string level, string gender, int language)
        {
            return CBO.FillCollection<TravelGuideCashInfo>(SQL.ListTravelGuideBy( level,gender, language));
        }
    }
}
